{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Portfolio PR","Trades","TCD"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":4},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Portfolio PR","index":0,"n_rows":6,"n_cols":24,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,20,3,22],[4,20,4,22],[5,20,5,22]]}
["Direction","ISIN","Nom du titre","Date de transaction","Prix de revient","Quantité","Montant investi","Stop-Loss","Target","Risk-Reward","MtM 27.03.2020","Performance","Montant MtM","Target reach","Stop reach"," Analysis","Motif AT et/ou F","Periode hold days","Periode hold months"]
["Long","LU0854423687","LYXOR ETF MSC GLDE",43910,64.625,62,{"$f":"F2*E2","v":4006.75},55,85,{"$f":"($I2-$E2)/($E2-$H2)","v":2.116883116883117},67,{"$f":"IF($K2<=$H2,0,($K2-$E2)/$E2)","v":3.6750483558994199E-2},{"$f":"IF($K2<=$H2,$F2*H2,$F2*$K2)","v":4154},{"$f":"IF($K2>=$I2,\"Yes\",\"No\")","v":"No"},"No","Coronavirus crisis, economy recovery and states, central banks stimulus","F",{"$f":"_xlfn.DAYS(TODAY(),$D2)","v":288},{"$f":"(_xlfn.DAYS(TODAY(),$D2))/30","v":9.6}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portfolio global return:",null,null,{"$f":"(SUM($M:$M)-SUM($G:$G))/SUM($G:$G)","v":3.6750483558994199E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portfolio capital:",null,null,{"$f":"SUM($G:$G)","v":4006.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portfolio MtM:",null,null,{"$f":"SUM($M:$M)","v":4154}]

{"sheet":"Trades","index":1,"n_rows":17,"n_cols":29,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,25,0,27],[1,25,1,27],[2,25,2,27]]}
["Direction","ISIN","Nom du titre","Date de transaction","Prix de revient","Quantité","Montant investi","Stop-Loss","Target","RisP-Reward","Exit Price","Performance","Montant MtM","Target reach","Stop reach","Trading costs","Net P&L","Exit date","Analysis","Motif AT et/ou F","Periode hold days","Periode hold months",null,null,null,"Portfolio average return:",null,null,{"$f":"AVERAGE(L:L)","v":0.41760904684975758}]
["Long","FR0000120685","NATIXIS",43913,2.476,2026,{"$f":"F2*E2","v":5016.3760000000002},1.4710000000000001,4.3,{"$f":"($I2-$E2)/($E2-$H2)","v":1.8149253731343284},3.51,{"$f":"IF($K2<=$H2,0,($K2-$E2)/$E2)","v":0.41760904684975758},{"$f":"IF($K2<=$H2,$F2*H2,$F2*$K2)","v":7111.2599999999993},{"$f":"IF($K2>=$I2,\"Yes\",\"No\")","v":"No"},"No",{"$f":"G2*0.006+M2*0.006","v":72.765816000000001},{"$f":"(M2-G2)-P2","v":2022.118183999999},43917,"Coronavirus crisis, economy recovery and states, central banks stimulus","F",{"$f":"_xlfn.DAYS($R2,$D2)","v":4},{"$f":"(_xlfn.DAYS(TODAY(),$D2))/30","v":9.5},null,null,null,"Total traded capital:",null,null,{"$f":"SUM($G:$G)","v":5016.3760000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P&L:",{"$f":"SUM(Q2:Q16)","v":2022.118183999999}]

{"sheet":"TCD","index":2,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Values",null,null,null,null,null,"Row Labels","Periode hold months","Average of Performance","Count of Montant MtM",null,"Row Labels","Average of Performance"]
["Motif AT et/ou F","Average of Performance","Count of Montant MtM",null,null,null,null,"No",null,0.17539651837524167,1,null,"(blank)"]
["F",0.17539651837524167,1,null,null,null,null,"No",null,0.17539651837524167,1,null,0.23333333333333334,0.17539651837524167]
["(blank)",null,null,null,null,null,null,2.116883116883117,0.23333333333333334,0.17539651837524167,1,null,"Grand Total",0.17539651837524167]
["Grand Total",0.17539651837524167,1,null,null,null,null,"(blank)"]
[null,null,null,null,null,null,null,"(blank)"]
[null,null,null,null,null,null,null,"(blank)","(blank)"]
[null,null,null,null,null,null,null,"Grand Total",null,0.17539651837524167,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Row Labels","Average of Performance"]
[2.116883116883117,0.17539651837524167]
["(blank)"]
["Grand Total",0.17539651837524167]